forum

home / developersection / forums / how to get connection string from app.config file in vc#.

How to get connection string from app.config file in VC#.

James Smith 6901 30-Jul-2011

Hi,

I would like to access connection string from app.config file but am not able to perform it. I am using C# as a programing language and visual studio 2010 IDE on windows 7 64 bit plateform.

Help needed.

Thanks.

c#

Updated on 30-Jul-2011

James Smith

Other

Message

Can you answer this question?

2 Answers

30-Jul-2011

Hi james,

You can use following line of code to access connection string from app.config file.

string cs = System.Configuration.ConfigurationSettings.AppSettings["cs"].ToString();

For this app.config file.

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <appSettings>
    <add value="DataSource=a;User Id=ccc;" key="cs"/>
  </appSettings>
</configuration>

Thanks.

30-Jul-2011

James,

Here you go..

http://www.mindstick.com/Articles/6053eec1-02c0-4e09-ab74-c288d8ed41b6/?Connection%20String%20using%20App.config

http://www.mindstick.com/Articles/176ace46-e15b-472c-8dda-f4941639f7f6/?Creating%20Globalized%20Connection%20String%20in%20.Net%20Framework%20using%20Attached%20Database

http://www.mindstick.com/Blog/132/Globalized%20Connection%20String

http://social.msdn.microsoft.com/Forums/en-GB/adodotnetdataproviders/thread/9a8c9f5a-092e-4c4a-87bb-9f35d8f55da1

MindStick Training